Item Quantity Master (IV00102)

azurecurve Products Microsoft Dynamics GP (0)InventoryItem Quantity Master (IV00102)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00102

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Item Quantity Master
Physical Name: IV00102
Technical Name: IV_Item_MSTR_QTYS

Group Display Name: Item Master
Group Technical Name: Item Master

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Item Quantity Master'].ITEMNMBR AS 'Item Quantity Master-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM IV00102 AS ['Item Quantity Master'] INNER JOIN IV00101 AS ['Item Master'] ON ['Item Quantity Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
2	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Item Quantity Master'].LOCNCODE AS 'Item Quantity Master-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM IV00102 AS ['Item Quantity Master'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Item Quantity Master'].LOCNCODE = ['Site Setup'].LOCNCODE
3	BINNMBR	Bin Number	String	STR20	20
4	RCRDTYPE	Record Type	Integer	INT1	1
5	PRIMVNDR	Primary Vendor	String	STR_15_Vendor_ID	15
6	ITMFRFLG	Item Freeze Flag	Boolean	YN	0
7	BGNGQTY	Beginning QTY	Currency	DLR17_QTY_RBS0_STR	17
8	LSORDQTY	Last ORD QTY	Currency	DLR17_QTY_RBS0_UTR	17
9	LRCPTQTY	Last RCPT QTY	Currency	DLR17_QTY_RBS0_UTR	17
10	LSTORDDT	Last ORD Date	Date	DATE	6
11	LSORDVND	Last ORD Vendor	String	STR_15_Vendor_ID	15
12	LSRCPTDT	Last RCPT Date	Date	DATE	6
13	QTYRQSTN	QTY Requisitioned	Currency	DLR17_QTY_RBS0_UTR	17
14	QTYONORD	QTY On Order	Currency	DLR17_QTY_RBS0_UTR	17
15	QTYBKORD	QTY Back Ordered	Currency	DLR17_QTY_RBS0_UTR	17
16	QTY_Drop_Shipped	QTY Drop Shipped	Currency	DLR17_QTY_RBS0_UTR	17
17	QTYINUSE	QTY In Use	Currency	DLR17_QTY_RBS0_UTR	17
18	QTYINSVC	QTY In Service	Currency	DLR17_QTY_RBS0_UTR	17
19	QTYRTRND	QTY Returned	Currency	DLR17_QTY_RBS0_UTR	17
20	QTYDMGED	QTY Damaged	Currency	DLR17_QTY_RBS0_UTR	17
21	QTYONHND	QTY On Hand	Currency	DLR17_QTY_RBS0_STR	17
22	ATYALLOC	QTY Allocated	Currency	DLR17_QTY_RBS0_UTR	17
23	QTYCOMTD	QTY Committed	Currency	DLR17_QTY_RBS0_UTR	17
24	QTYSOLD	QTY Sold	Currency	DLR17_QTY_RBS0_UTR	17
25	NXTCNTDT	Next Count Date	Date	DT	8
26	NXTCNTTM	Next Count Time	Time	TM6	6
27	LSTCNTDT	Last Count Date	Date	DT	8
28	LSTCNTTM	Last Count Time	Time	TM6	6
29	STCKCNTINTRVL	Stock Count Interval	Integer	INT4_U0	4
30	Landed_Cost_Group_ID	Landed Cost Group ID	String	STR15_LBAU	15
31	BUYERID	Buyer ID	String	STR15_User_ID	15
32	PLANNERID	Planner ID	String	STR15_User_ID	15
33	ORDERPOLICY	Order Policy	Integer	DDL_Order_Policy	0
34	FXDORDRQTY	Fixed Order Qty	Currency	DLR17_QTY_RBS0_UTR	17
35	ORDRPNTQTY	Order Point Qty	Currency	DLR17_QTY_RBS0_UTR	17
36	NMBROFDYS	Number of Days	Integer	INT3_U0	3
37	MNMMORDRQTY	Minimum Order Qty	Currency	DLR17_QTY_RBS0_UTR	17
38	MXMMORDRQTY	Maximum Order Qty	Currency	DLR17_QTY_RBS0_UTR	17
39	ORDERMULTIPLE	Order Multiple	Currency	DLR17_QTY_RBS0_UTR	17
40	REPLENISHMENTMETHOD	Replenishment Method	Integer	DDL_Replenishment_Method	0
41	SHRINKAGEFACTOR	Shrinkage Factor	Currency	DLR1_4	6
42	PRCHSNGLDTM	Purchasing Lead Time	Currency	DLR4_U2	9
43	MNFCTRNGFXDLDTM	Manufacturing Fixed Lead Time	Currency	DLR4_U2	9
44	MNFCTRNGVRBLLDTM	Manufacturing Variable Lead Time	Currency	DLR3_U4	8
45	STAGINGLDTME	Staging Lead Time	Currency	DLR4_U2	9
46	PLNNNGTMFNCDYS	Planning Time Fence Days	Integer	INT3_U0	3
47	DMNDTMFNCPRDS	Demand Time Fence Periods	Integer	INT3_U0	3
48	INCLDDINPLNNNG	Included in Planning	Boolean	CB	0
49	CALCULATEATP	Calculate ATP	Boolean	CB	0
50	AUTOCHKATP	Auto Check ATP	Boolean	CB	0
51	PLNFNLPAB	Plan Final PAB	Boolean	CB	0
52	FRCSTCNSMPTNPRD	Forecast Consumption Period	Integer	DDL_Forecast_Consumption_Period	0
53	ORDRUPTOLVL	Order Up To Level	Currency	DLR17_QTY_RBS0_UTR	17
54	SFTYSTCKQTY	Safety Stock Qty	Currency	DLR17_QTY_RBS0_UTR	17
55	REORDERVARIANCE	Reorder Variance	Currency	DLR17_QTY_RBS0_UTR	17
56	PORECEIPTBIN	Purchase Receipt Bin	String	STR15_Bin	15
57	PORETRNBIN	Purchase Returns Bin	String	STR15_Bin	15
58	SOFULFILLMENTBIN	SO Fulfillment Bin	String	STR15_Bin	15
59	SORETURNBIN	SO Return Bin	String	STR15_Bin	15
60	BOMRCPTBIN	BOM Receipt Bin	String	STR15_Bin	15
61	MATERIALISSUEBIN	Material Issues Bin	String	STR15_Bin	15
62	MORECEIPTBIN	MO Receipt Bin	String	STR15_Bin	15
63	REPAIRISSUESBIN	Repair Issues Bin	String	STR15_Bin	15
64	ReplenishmentLevel	Replenishment Level	Integer	DDL_ReplenishmentLevel	0
65	POPOrderMethod	POP Order Method	Integer	DDL_POP_OrderMethod	0
66	MasterLocationCode	Master Location Code	String	STR10_Location_Code	10
67	POPVendorSelection	POP Vendor Selection	Integer	DDL_POP_VendorSelection	0
68	POPPricingSelection	POP Pricing Selection	Integer	DDL_POP_PriceSelection	0
69	PurchasePrice	Purchase Price	Currency	DLR17_RBS0_UTR$	17
70	IncludeAllocations	Include Allocations	Boolean	CB_IncludeAllocations	0
71	IncludeBackorders	Include Backorders	Boolean	CB_IncludeBackorders	0
72	IncludeRequisitions	Include Requisitions	Boolean	CB_IncludeRequisitions	0
73	PICKTICKETITEMOPT	Picking Ticket Item Option	Integer	DDL_PickingTicketItemOption	0
74	INCLDMRPMOVEIN	IncludeMRPMoveIn	Boolean	IncludeMRPMoveIn	0
75	INCLDMRPMOVEOUT	IncludeMRPMoveOut	Boolean	IncludeMRPMoveOut	0
76	INCLDMRPCANCEL	IncludeMRPCancel	Boolean	IncludeMRPCancel	0
77	Move_Out_Fence	Move-Out Fence	Integer	INT3_U0	3
78	INACTIVE	Inactive	Boolean	CB_Inactive	0

azurecurve Products Microsoft Dynamics GP (0)InventoryItem Quantity Master (IV00102)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply